package com.wl.zlmanage.mapper;


import com.wl.zlmanage.bean.ApplyInfo;
import com.wl.zlmanage.bean.Profit;
import com.wl.zlmanage.bean.SignMatchInfo;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface SignMatchInfoMapper {
    List<SignMatchInfo> getSignMatchList(@Param("begainTime") String begainTime,@Param("endTime") String endTime);

    Double getExpendTotal(@Param("signId") Integer signId,@Param("signType") Integer signType,@Param("month") String month);

    Integer getSignMatchCount(@Param("signId") Integer signId);

    Double getQyApplySum(@Param("signId") Integer signId,@Param("personSignId") Integer personSignId,@Param("month") String month);

    Double getRcApplySum(@Param("personSignId") Integer personSignId,@Param("month") String month);

    List<Profit> getUserProfit(@Param("userId") Integer userId,@Param("accountList") List<String> accountList, @Param("updateTime") String updateTime);

    Integer saveProfit(@Param("pt") Profit pt);

    Integer deleteProfit(@Param("updateTime") String updateTime);

    List<ApplyInfo> getApplyBySignId(@Param("signId") Integer signId);

    List<Profit> getQyProfitTotal(@Param("updateTime") String updateTime);

    List<Profit> getUserProfitList(@Param("page") int page, @Param("limit") int limit,@Param("accountList") List<String> accountList,@Param("updateTime") String updateTime);

    Integer getUserProfitListCount(@Param("accountList") List<String> accountList,@Param("updateTime") String updateTime);

    Integer addProfitHistory(@Param("matchId") Integer matchId,@Param("profit") Double profit,@Param("account") String account);

    Integer updateProfitHistory(@Param("matchId") Integer matchId,@Param("profit") Double profit,@Param("account") String account);

    Double getCountedProfit(@Param("matchId") Integer matchId,@Param("account") String account);

    Integer getProfitHistory(@Param("matchId") Integer matchId,@Param("account") String account);
}
